Skip to main content

Formatting Table Widget

Formatting Table: This video contains how can user format and add any desired change to the table in AIV.

tip

Only users with Dashboard privilege have access to this section!

Read 5 minutes tutorial here.

To Format a Table follow the steps below:

  • Value Formatter
  1. Click on Hamburger Icon.

    dashboard -icon 1

  2. Click on visualization tab and open Table Widget in edit mode.

    dashboard -icon 1

  3. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard.

  4. Enter Following details in General Property.

  • Dataset: salesb.ds
  • Select all the field in Dataset Columns
  1. Fill above details as shown in figure below:

    dashboard -icon 1

  2. Click on Formatting Property.

  3. Enter following details in Value Formatter.

  • Select Value: orderNumber
  • Toggle Format Value
  • Decimal Places: 2
  • Before Symbol: $
  • After Symbol: %
  • Toggle 1000s Separator
  1. Fill above details, As shown in figure below:

    dashboard -icon 1

  2. Click on Preview and Save and Exit. 10. Now, match your Table Widget with the below example, it should look like the figure below:

    dashboard -icon 1

  • Miscellaneous Properties
  1. Click on Formatting Property.

  2. Enter following details in Miscellaneous Properties.

  • Select Pagination
  • Pagination Size:** 12
  1. Fill above details, As shown in figure below:

    dashboard -icon 1

  2. Click on Preview and Save and Exit.

    dashboard -icon 1

  3. Enter following details in Miscellaneous Properties.

  • Select Sub Group Total
  • Select Group Total
  • Select Conditional Formatting Export
  1. Fill above details, As shown in figure below:

    dashboard -icon 1

  2. Click Preview and Save and Exit.

    dashboard -icon 1

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    dashboard -icon 1